--------------------------------------------------
-- Socrates_Party
IF NOT EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[Socrates_Party]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
	CREATE TABLE [dbo].[Socrates_Party]
	(
		ID					integer NOT NULL,
		TypeID				varchar (1) NOT NULL,
		FirstName			varchar(35) NOT NULL,
		Surname				varchar(35) NOT NULL
	);
END
GO

-- drop TABLE [dbo].[Socrates_Party]